/****** Object:  Stored Procedure dbo.spr_InsertDBVisaTypes  ******/

 use [TourIS]
 GO

 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spr_InsertDBVisaTypes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure [dbo].[spr_InsertDBVisaTypes]
 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS OFF
 GO

 CREATE  PROCEDURE [dbo].[spr_InsertDBVisaTypes]
 (
	@parprice int,
	@visadays int,
	@visatypeid int,
	@visatypename varchar(50)
 )
 AS

 BEGIN
	SET NOCOUNT ON
	DECLARE @Err int

	INSERT INTO [VisaTypes]
	(
		[ParPrice],
		[VisaDays],
		[VisaTypeId],
		[VisaTypeName]
	)
	VALUES
	(
		@parprice,
		@visadays,
		@visatypeid,
		@visatypename
	)

	SET @Err = @@Error
	RETURN @Err
 END

 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS ON
 GO

